Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors?
نویسندگان
چکیده
The research presented in this paper establishes a valid, and simplified, revision of previous spreadsheet error classifications. This investigation is concerned with the results of a web survey and two web-based gender and domain-knowledge free spreadsheet error identification exercises. The participants of the survey and exercises were a test group of professionals (all of whom regularly use spreadsheets) and a control group of students from the University of Greenwich (UK). The findings show that over 85% of users are also the spreadsheet’s developer, supporting the revised spreadsheet error classification. The findings also show that spreadsheet error identification ability is directly affected both by spreadsheet experience and by error-type awareness. In particular, that spreadsheet error-type awareness significantly improves the user’s ability to identify, the more surreptitious , qualitative error.
منابع مشابه
Introducing a Taxonomy for Classifying Qualitative Spreadsheet Errors
Most organizations use large and complex spreadsheets that are embedded in their mission-critical processes and are used for decision-making. Identification of the various types of errors that can be present in these spreadsheets is, therefore, an important first step to creating controls that organizations can use to govern their spreadsheets. While a considerable amount of research on quantit...
متن کاملIn Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors
Most organizations use large and complex spreadsheets that are embedded in their mission-critical processes and are used for decision-making purposes. Identification of the various types of errors that can be present in these spreadsheets is, therefore, an important control that organizations can use to govern their spreadsheets. In this paper, we propose a taxonomy for categorizing qualitative...
متن کاملIncorporating Incremental Validation and Impact Analysis into Spreadsheet Maintenance: An Empirical Study
Spreadsheet language programs, which include commercial spreadsheets, are among the most common form of software in use today. Unlike more "traditional" forms of software however, spreadsheet language programs are created and maintained by end-users with little or no programming experience. As a result, a high percentage of these programs contain errors. Unfortunately, software engineering rese...
متن کاملTemplate Parsing with User Feedback
Spreadsheets are among the most widely used end-user programming systems. According to some estimates, up to 90% of spreadsheets have non-trivial errors in them [7]. In many cases, spreadsheet errors have resulted in huge financial losses for companies. Spreadsheets are also in use in Science and Mathematics education in schools primarily because they offer a flexible modeling environment. With...
متن کاملAn Empirical Study on End-users Productivity Using Model-based Spreadsheets
Spreadsheets are widely used, and studies have shown that most end-user spreadsheets contain nontrivial errors. To improve end-users productivity, recent research proposes the use of a model-driven engineering approach to spreadsheets. In this paper we conduct the first systematic empirical study to assess the effectiveness and efficiency of this approach. A set of spreadsheet end users worked ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید
ثبت ناماگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید
ورودعنوان ژورنال:
- CoRR
دوره abs/0803.0167 شماره
صفحات -
تاریخ انتشار 2006